<%@page import="com.sinba.common.utils.TranType"%>
<%@page import="java.util.ArrayList"%>
<%@page import="com.sinba.common.system.dto.SingleGroupReportStatDTO"%>
<%@page import="com.sinba.common.dto.PageDTO"%>
<%@page import="com.sinba.common.system.dto.TransactionRecordDTO"%>
<%@page import="com.sinba.common.system.service.ITransactionRecordService"%>
<%@page import="com.sinba.common.user.service.IAccountService"%>
<%@page import="org.springframework.web.context.support.WebApplicationContextUtils"%>
<%@page import="org.springframework.context.ApplicationContext"%>
<%@page import="java.util.List"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%> 
<%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt"%>
<%@ include file="../language.jsp" %>
<%
if(session.getAttribute("password2")==null){
	response.sendRedirect( "login2.jsp?pageUrl=user/dynamicAccountDetails.jsp");
	return;
}

ApplicationContext ac = WebApplicationContextUtils.getWebApplicationContext(getServletContext());
ITransactionRecordService transactionRecordService = (ITransactionRecordService)ac.getBean("transactionRecordService");
TransactionRecordDTO trDTO = new TransactionRecordDTO();
trDTO.setLoginName((String)session.getAttribute("loginName"));
int pages = 1;
String sidx = "recordId";
String sord="desc";
Object param1 = request.getParameter("trDTO.transactionType");

if(param1!=null 
&& param1!="" 
&& !"null".equals(param1)){
	trDTO.setTransactionType(request.getParameter("trDTO.transactionType"));
	pages=1;
}
if(request.getParameter("pages")!=null && request.getParameter("pages")!=""){
	pages = Integer.parseInt(request.getParameter("pages"));
}
int rows = 10;
int start = ( pages - 1 ) * rows;
trDTO.setStart( start );
trDTO.setLimit( rows );

trDTO.setDtype("Dynamic");
PageDTO pageDTO = transactionRecordService.findTransactionRecordPager(trDTO, sord, sidx);
if(pageDTO!=null){
	pageDTO.setPage( pages );
	pageDTO.setRows( rows );
}
request.setAttribute("pageDTO",pageDTO);

//统计：
Double income = 0D;
TransactionRecordDTO trDto1 = new TransactionRecordDTO();
trDto1.setInOrExp("income");
trDto1.setDtype("Dynamic");
trDto1.setLoginName((String)session.getAttribute("loginName"));
List<SingleGroupReportStatDTO> sgrs = transactionRecordService.statAccount(trDto1);
for(SingleGroupReportStatDTO sgr : sgrs){
	if(sgr.getAggField()!=null){
		income = income+sgr.getAggField();
	}
}
request.setAttribute("income",income);


Double expenditure = 0D;
TransactionRecordDTO trDto2 = new TransactionRecordDTO();
trDto2.setInOrExp("expenditure");
trDto2.setDtype("Dynamic");
trDto2.setLoginName((String)session.getAttribute("loginName"));
List<SingleGroupReportStatDTO> sgrs2 = transactionRecordService.statAccount(trDto2);
for(SingleGroupReportStatDTO sgr : sgrs2){
	if(sgr.getAggField()!=null){
		expenditure = expenditure+sgr.getAggField();
	}
}
request.setAttribute("expenditure",expenditure);
request.setAttribute("transactionTypes", TranType.Alls);

%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>

<meta charset="UTF-8">
<title><fmt:message key="i18n.dyMoneyDetail"/>-<fmt:message key="i18n.title"/> </title>
<meta name="apple-mobile-web-app-capable" content="yes" />
<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
<meta name="viewport" content="width=device-width, initial-scale=1" />


<!-- Bootstrap framework -->
    <link rel="stylesheet" href="bootstrap/css/bootstrap.min.css" />
    <link rel="stylesheet" href="bootstrap/css/bootstrap-responsive.min.css" />
<!-- breadcrumbs-->
	<link rel="stylesheet" href="lib/jBreadcrumbs/css/BreadCrumb.css" />
<!-- main styles -->
    <link rel="stylesheet" href="css/sub_page_main_style.css" />

<!--[if lte IE 8]>
    <link rel="stylesheet" href="css/ie.css" />
    <script src="js/ie/html5.js"></script>
    <script src="js/ie/respond.min.js"></script>
<![endif]-->


</head>
<body style="height:800px">


<!-- 主体内容 -->
<div id="contentwrapper">
	<div class="main_content">
		 <nav>
            <div id="jCrumbs" class="breadCrumb module">
                <ul>
                    <li>
                        <a href="main.jsp"><i class="icon-home"></i></a>
                    </li>
                    <li>
                        <a href="#"><fmt:message key="i18n.moneyManage"/></a>
                    </li>
                    <li>
                        <a href="#"><fmt:message key="i18n.dynamicAccountDetails"/></a>
                    </li>
                </ul>
            </div>
         </nav>
         
         <h3 class="heading"><fmt:message key="i18n.totalincome"/>:<fmt:formatNumber value="${income}" pattern="#0.0000"/>，
	<fmt:message key="i18n.totalZhichu"/>：<fmt:formatNumber value="${expenditure}" pattern="#0.0000"/>
	<%--<fmt:message key="i18n.balance"/>：<fmt:formatNumber value="${income - expenditure}" pattern="#0.0000"/>--%></h3>
         
         
         
      <h3 class="heading"><fmt:message key="i18n.dynamicAccountDetails"/></h3>


    <div class="listCont">
    	<div class="listTable lttno">
    		<form id="bonusSeachForm" action="dynamicAccountDetails.jsp" method="post">
				<input name="sidx" value="recordId" type="hidden" >
				<input name="sord" value="desc" type="hidden" >
				<input name="trDTO.searchType" value="bonus" type="hidden" >
				<input name="trDTO.loginName" value="${session.loginName }" type="hidden" >
				<table width="100%">
							<tr>
							 	<td>
							 	   <fmt:message key="i18n.type"/> <select name="trDTO.transactionType">
							 	   	<option value="">--<fmt:message key="i18n.pelaseSelect"/>--</option>
							 	   	<c:forEach items="${transactionTypes}" var="tts">
							 	   		<option value="${tts}"><fmt:message key="${tts}" /></option>
							 	   	</c:forEach>
							 	   </select>
							 	</td>
							 	<td>
							 		<fmt:message key="i18n.jiesuanData"/><input name="trDTO.startTime" class="easyui-datebox"></input> <fmt:message key="i18n.to"/>  <input name="trDTO.endTime" class="easyui-datebox"/> 
							 		<a style="cursor: pointer;" id="doSeach"><input type="button" value="<fmt:message key="i18n.serach"/>" /></a>
							 	</td>
							</tr>
				</table>
			</form>
			
			<table class="table table-bordered table-striped" id="bonusTable">
				<thead>
					
					<tr class="color1">
						<th><fmt:message key="i18n.type"/></th>
						<th><fmt:message key="i18n.jiaoyiUser"/></th>
						<th><fmt:message key="i18n.income"/></th>
						<th><fmt:message key="i18n.zhichu"/></th>
						<th><fmt:message key="i18n.balance"/></th>
						<th><fmt:message key="i18n.operationTime"/></th>
						<th><fmt:message key="i18n.remark"/></th>
					</tr>
					
				</thead>
				<tbody>
					<c:forEach items="${pageDTO.data}" var="data">
						<tr>
							<td>
								<fmt:message key="${data.transactionType }"/>
							</td>
							<td>${data.transactionObject}</td>
							<td><fmt:formatNumber value="${data.income}" pattern="#0.0000"/></td>
							<td><fmt:formatNumber value="${data.expenditure}" pattern="#0.0000"/></td>
							<td><fmt:formatNumber value="${data.balance}" pattern="#0.0000"/></td>
							<td><fmt:formatDate value="${data.optDate}" pattern="yyyy-MM-dd HH:mm:ss"/></td>
							<td>${data.remark}</td>
						</tr>
					</c:forEach>
					<c:if test="${empty pageDTO.data}">
						<tr>
							<td colspan="7" align="center"><fmt:message key="i18n.noData"/>!</td>
						</tr>
					</c:if>
				</tbody>		        		
			</table>
			
			
			<!-- 分页 start -->
			<div class="page">
			<div id="tr_recommendGrid_pager" class="page_r">
				<ul>
					<li><a href="dynamicAccountDetails.jsp?pages=1&trDTO.transactionType=<%=request.getParameter("trDTO.transactionType") %>"><fmt:message key="i18n.firstPage"/></a></li>
					<c:if test="${pageDTO.page!=1}">
						<li><a href="dynamicAccountDetails.jsp?pages=${pageDTO.page-1}&trDTO.transactionType=<%=request.getParameter("trDTO.transactionType") %>"><fmt:message key="i18n.upPage"/></a></li>
					</c:if>
					<li><a>${pageDTO.page}/${pageDTO.total}</a></li>
					<c:if test="${pageDTO.page+1<=pageDTO.total}">
						<li><a href="dynamicAccountDetails.jsp?pages=${pageDTO.page+1}&trDTO.transactionType=<%=request.getParameter("trDTO.transactionType") %>"><fmt:message key="i18n.nextPage"/></a></li>
					</c:if>
					<li><a href="dynamicAccountDetails.jsp?pages=${pageDTO.total}&trDTO.transactionType=<%=request.getParameter("trDTO.transactionType") %>"><fmt:message key="i18n.endPage"/></a></li>
					<li><a><fmt:message key="i18n.total"/>${pageDTO.totalSize}<fmt:message key="i18n.tiao"/></a></li>
				</ul>
			</div>
			</div>
			<!-- 分页 end  -->
			
			
    	</div>
    </div>	

</div></div>


<script type="text/javascript" src="../scripts/jquery/jquery-1.4.2.min.js"></script>
<script>

$(function(){
	//showTransRecord('tr_recommend_table','tr_recommend_pager','recommend',1,10,'optDate','desc');
	//showDirectPushUser('tr_recommendGrid_table','tr_recommendGrid_pager','${user.loginName}',1,10,'registerTime','desc');
    $("#doSeach").click(function(){
    	$("#bonusSeachForm").submit();
    });
})

</script>

</body>
</html>